Easy data surfing
I use Oracle SQL Developer as an editor to run various queries and export data to my desired format as Excel or CSV files. I usually use …
Overview
What is SQL Developer?
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
Pricing
N/A
Unavailable
What is SQL Developer?
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
7 people also want pricing
Alternatives Pricing
What is Rider?
JetBrains supports .NET development with Rider, a .NET IDE based on the IntelliJ platform and ReSharper.
What is The Welkin Suite?
The Welkin Suite offers an integrated development environment with 105 features (and growing). The vendor aims to help you automate the chores of development, and therefore enhance your coding velocity and increase the quality of your deliverable code.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is SQL Developer?
Oracle SQL Developer is an integrated development environment (IDE)
which provides editors for working with SQL, PL/SQL, Stored Java
Procedures, and XML in Oracle databases.
SQL Developer Competitors
SQL Developer Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Frequently Asked Questions
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
Reviewers rate Oracle University Experience highest, with a score of 7.9.
The most common users of SQL Developer are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(489)Attribute Ratings
Reviews
(1-8 of 8)Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Oracle SQL Developer is used to solve production issues for our client. It is used across the whole organization by different support and development teams. The business problems that it solves is production issue that occur when the business runs. Using Oracle SQL Developer we ensure that our business runs smoothly.
- The various contents of a database can be viewed using the connection tree
- We can run SQL queries to generate reports in various formats
- Debugging of queries is smooth
- More RAM usage by SQL Developer which makes it slow sometimes for big queries
- The database automatically gets disconnected when it is idle for sometime
- Auto-completion of queries is not available
April 13, 2021
Software for everyone using DB
Oracle SQL Developer is used by each and every department in my organization but not all employees work on it. Mainly it is used to store data my organization works on. It is used to keep records of my company for a long time without any need to delete--also hassle free maintenance of data.
- Simple UI. Even new joiners can easily use it.
- Autocomplete feature. It recommends a completion for every line.
- Debugging is easy. Oracle SQL Developer displays what ever the error is.
- Supports various kind of DB. Not just SQL.
- Easy installation and setup.
- It is free to use and one doesn't need to buy anything.
- Easily export data into different formats like Excel, TSV file, text file, html, etc.
- There are fewer features compared to other software available in market.
- Good quality reporting, sorting ,filtering features are not available.
- Lags upon heavy usage.
- Connection from DB gets disconnected if query is stopped.
- Query running status still comes even if at the backend the query has been stopped and person keeps on waiting.
December 12, 2019
Reliable tool for Oracle DBs
SQL developer is still being used as one of the main tools for manipulating our databases. Although for development, the built-in tools suffice, this professional tool is still used widely by our DBAs. A reliable, and well-supported tool, which is excellent to utilize the power of PL/SQL and Oracle databases.
- Database manipulation and SQL editing.
- PL/SQL code development.
- Modern IDE like features, like wider linting support.
- More customization.
September 18, 2019
Looking for a better way to Develop SQL
To develop SQL Code and design database objects along with data migration across the whole organization. It allows us to import and export data to other data platforms. And we can generate quick DDL and review the tables/views and contents effectively. Since we are new to the tool and trying to migrate our data to the cloud, it would be helpful if the data export feature to the cloud could be improved.
- It lets us create new objects easily and modify the DDL within the tool quite easily.
- I love the data review tab that shows the data quickly and helps us profile the data.
- Exporting data from one object to another is great.
- Import/export data to the cloud.
- Does not do a good job of auto-connecting to a previous connection and you have to go through a couple of clicks and refresh.
February 12, 2019
Oracle SQL Developer -- A Very Useful Tool!
Oracle's SQL Developer is used throughout the IT department at my company. It is extremely useful for querying our various databases. It is used for researching, troubleshooting, fixing (insert, update, delete), etc. It is a very powerful tool and is critical to our IT department's daily functionality. I have personally been using SQL Developer since it was first released in approximately 2006-2007.
- SQL Developer aids in writing queries in several ways, such as syntax highlighting, code formatting, auto-complete suggestions, error displays, and much more.
- You can easily export your results into a variety of formats such as Excel, CSV, Insert statements, etc.
- The product allows you to store your database connections so you only need to select from a drop-down which database (or which user account) you want to use to execute a query or script.
- You can view all database objects under specific schemas or user accounts and drill down to the most granular details.
- There are a fair number of bugs that are identified in the product regularly, but Oracle generally releases updates several times per year to address issues and introduce new features.
- Although you can collapse certain sections of code, it is not always reliable and sometimes auto-expands.
- Some settings are not retained from session to session. For example, I like specific columns to be expanded in my results so I can see the entire value.
January 14, 2019
SQL Developer is a must-have for Oracle
My team and I use SQL Developer to develop and test database queries implemented in and for our various end-user reports. SQL Developer is used by other teams throughout the organization for various other purposes. By using SQL Developer, I am able to quickly and easily write, execute and debug queries. I am also able to generate and explain plans to help me evaluate and tune queries for the greatest performance.
- Highlights syntax assisting in the proper development and completion of statements.
- Allows toggling of breakpoints for SQL debugging. By using these breakpoints, I can evaluate variable values real-time as the query executes.
- Highlights syntax errors and upon hover, displays proper syntax with a direct link to the appropriate documentation for the statement in question.
- It would be helpful if one could quickly and easily integrate another editor into this tool. Although the provided editor is quite useful, other 3rd-party editors are much more powerful.
- SQL Developer should be able to easily integrate with source control providers other than GIT and Subversion.
- The syntactical auto-completion should allow some keystroke to complete and suggested statement rather than requiring a mouse-click to accept the suggestion.
January 31, 2018
Why Should i Trust SQL?
SQL Dev is being used in different projects since I'm working for a Consultant Company, it's totally related to the project requirements. It's so helpful to manage and query all the DWH instances and the database themselves.
- Great Activity Monitoring
- Great Management of Databases and Objects on the instance
- Great Query Optimization module
- Machine Learning Functionalities
- Auto-format of the code
- Resource Management
SQL Developer is used by the Information Services Department as well as the Prospect Development Team. We use this software to leverage our extensive database. We have a large number of tables in our database that need to readily accessed. SQL Developer enables our teams to effectively query our database in real time.
- Enables our team to quickly and effectively access information from our database.
- Produces an easily readable view of the SQL scripts being written with debugging suggestions clearly marked. This helps with writing scripts in real time. I am able to see exactly where my script is creating an error.
- SQL Developer auto completes table names, commands, functions, and field names. This is very helpful when trying to quickly write SQL script.
- The interface is easy to navigate between input and output.
- Encrypted connection to the database can be a little difficult especially when you have multiple database instances required for development and production.
- The interface can be made to be a bit more user-friendly in terms of troubleshooting and suggestions for better utilization of the software.
- Default settings should be easier to set such as keeping the line numbers in view at all times.